StudentAccountTransaction 
EntityType  Independent 
Logical Entity Name  StudentAccountTransaction 
Default Table Name  SaTrans 
Logical Only  NO 
Definition 
 
Note 
 

StudentAccountTransaction Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
ClassSectionId(FK)    INTEGER  YES 
 
StudentAccountTransactionId(PK)    INTEGER  NO 
 
StudentId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
Source    CHAR(1)  NO 
 
Type    CHAR(1)  NO 
 
CampusId(FK)    INTEGER  YES 
 
BillingTransactionCode    CHAR(8)  NO 
 
TransactionNumber    NUMERIC(4, 0)  NO 
 
Description    VARCHAR(100)  YES 
 
Status    CHAR(1)  NO 
 
TransactionDate    DATETIME  NO 
 
PostDate    DATETIME  NO 
 
TransactionAmount    MONEY(19, 4)  NO 
 
PaymentType    CHAR(1)  YES 
 
DiscountAmount    MONEY(19, 4)  NO 
 
AmountPaid    MONEY(19, 4)  NO 
 
BatchNumber    CHAR(8)  NO 
 
StudentRevenueDetailId(FK)    INTEGER  NO 
 
PaymentPeriodId    INTEGER  NO 
 
AcademicYearSequence    NUMERIC(3, 0)  NO 
 
TermId(FK)    INTEGER  YES 
 
Reference    CHAR(75)  NO 
 
CheckNumber    VARCHAR(20)  NO 
 
StudentCreditCardId(FK)    INTEGER  YES 
 
ReceiptNumber    VARCHAR(16)  YES 
 
AppliedDate    DATETIME  YES 
 
IsSentBack    BIT  NO 
 
BankAccountId(FK)    INTEGER  YES 
 
BankDepositId(FK)    INTEGER  YES 
 
AdmissionsRepId    INTEGER  NO 
 
CommRate    MONEY(19, 4)  NO 
 
CommPaid    BIT  NO 
 
CommDate    DATETIME  YES 
 
IsPostedToGeneralLedger    BIT  NO 
 
PostAccount    NVARCHAR(100)  NO 
 
OffsetAccount    NVARCHAR(100)  NO 
 
StudentAwardId(FK)    INTEGER  YES 
 
PaidDisbursementId(FK)    INTEGER  YES 
 
RefundId(FK)    INTEGER  YES 
 
StudentAccountBatchBillingId    INTEGER  YES 
 
RefundCalculationId    INTEGER  YES 
 
CreatedByUserId    INTEGER  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
DepositId    INTEGER  YES 
 
CreditCardAuthorizationNumber    CHAR(10)  YES 
 
CreditCardDeclineCode    CHAR(10)  YES 
 
SyAddressID    INTEGER  YES 
 
SaQTBatchID    INTEGER  YES 
 
SA1098T    CHAR(1)  NO 
 
AchBatchFileId(FK)    INTEGER  YES 
 
ReceiptPrintedDate    DATETIME  YES 
 
CreditCardBatchTransactionId(FK)    INTEGER  YES 
 
CashDrawerSessionId(FK)    INTEGER  YES 
 
IsManualCheckExtract    BIT  YES 
 
CourseId(FK)    INTEGER  YES 
 
TuitionDiscountPolicyId    INTEGER  YES 
 
OriginalStudentAccountTransactionId    INTEGER  YES 
 
AgencyBranchCreditCardId(FK)    INTEGER  YES 
 
CheckStatus    CHAR(1)  NO 
 
CheckClearedDate    DATETIME  YES 
 
IsPreviousYear1098t    BIT  NO 
 
MerchantProcessingCode    VARCHAR(19)  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
EFTNumber    VARCHAR(20)  YES 
 
EFTStatus    CHAR(1)  YES 
 
EFTClearedDate    DATETIME  YES 
 
CourseRefundPolicyId(FK)    INTEGER  YES 
 
CourseAmountToRetain    MONEY(19, 4)  YES 
 
RegistrationTermId    INTEGER  YES 
 
IsAutomatedProcess    BIT  NO 
 
StudentEnrollmentPeriodFeeId(FK)    INTEGER  YES 
 
IsGeneralLedgerStatusFlag    BIT  NO 
 
IsReissued    BIT  NO 
 
IsInPendingQueue    BIT  NO 
 
CashDrawerSessionId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodFeeId(FK)    INTEGER  YES 
 

StudentAccountTransaction Keys 
Key Name  Key Type  Keys 
SaTrans_SyAddressID_N_N_IDX  Inversion Entry  SyAddressID 
SaTrans_CheckNo_N_N_IDX  Inversion Entry  CheckNumber 
SaTrans_SaBillingBatchID_N_N_IDX  Inversion Entry  StudentAccountBatchBillingId 
SaTrans_SaBillCode_N_N_IDX  Inversion Entry  BillingTransactionCode 
SaTrans_Date_Sa1098T_Type_INCLUDE_N_N_idx  Inversion Entry  TransactionDate, SA1098T, Type 
satrans_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 
SaTrans_SaTuitionDiscountPolicyID_N_N_IDX  Inversion Entry  TuitionDiscountPolicyId 
SaTrans_saCashDrawerSessionID_N_N_IDX  Inversion Entry  CashDrawerSessionId 
SaTrans_SaACHBatchID_N_N_IDX  Inversion Entry  AchBatchFileId 
SaTrans_BatchNo_N_N_IDX  Inversion Entry  BatchNumber 
SaTrans_Date_N_N_IDX  Inversion Entry  TransactionDate 
Nk_satrans_SyAddressId  Inversion Entry  SyAddressID 
satrans_AdFeesId_N_N_IDX  Inversion Entry  StudentEnrollmentPeriodFeeId 
SaTrans_AmAgencyCCID_N_N_IDX  Inversion Entry  AgencyBranchCreditCardId 
SaTrans_OriginalSaTransId_N_N_IDX  Inversion Entry  OriginalStudentAccountTransactionId 
SaTrans_AdCourseID_N_N_IDX  Inversion Entry  CourseId 
SaTrans_SyCampusID_Date_N_N_IDX  Inversion Entry  TransactionDate 
SaTrans_AdEnrollId_AdTermId_SaBillCode_Source_Type_Amount_SaTransID_U_N_IDX  Alternate Key  BillingTransactionCode, Source, ClassSectionId 
SaTrans_SyStudentID_Date_AdTermID_Type_N_N_IDX  Inversion Entry  TransactionDate, Type 
SaTrans_SaTransID_U_C_IDX  PrimaryKey  StudentAccountTransactionId 
SaTrans_AdEnrollId_Date_N_N_IDX  Inversion Entry  TransactionDate, ClassSectionId 
SaTrans_CheckStatus_CheckClearedDate_CheckNo_SaBankAccountID_N_N_IDX  Inversion Entry  CheckStatus, CheckClearedDate, CheckNumber 
Nk_SaTransAdClassschedID  Inversion Entry  ClassSectionId 
SaTrans_SyCampusID_SaBankDepID_Type_Ref_Source_SaTransID_U_N_IDX  Alternate Key  Type, Reference, Source, ClassSectionId 
SaTrans_SyStudentID_TranNum_N_N_IDX  Inversion Entry  TransactionNumber 
SaTrans_AdTermID_Date_Sa1098T_N_N_IDX  Inversion Entry  TransactionDate, SA1098T 
SaTrans_PostDate_Source_SaBankAccountID_SaTransID_U_N_IDX  Alternate Key  PostDate, Source, ClassSectionId 
SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX  Alternate Key  Type, TransactionAmount, TransactionDate, ClassSectionId 

StudentAccountTransaction Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
AchBatchFile  Non-Identifying  Zero or One to Zero or More        AchBatchFileId  NO 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
BankDeposit  Non-Identifying  Zero or One to Zero or More        BankDepositId  NO 
Campus  Non-Identifying  Zero or One to Zero or More        CampusId  NO 
CashDrawerSession  Non-Identifying  Zero or One to Zero or More        CashDrawerSessionId  NO 
ClassSection  Non-Identifying  Zero or One to Zero or More        ClassSectionId  NO 
CreditCardBatchTransaction  Non-Identifying  Zero or One to Zero or More        CreditCardBatchTransactionId  NO 
CashDrawerSession  Non-Identifying  Zero or One to Zero or More        CashDrawerSessionId  NO 
ClassSection  Non-Identifying  Zero or One to Zero or More        ClassSectionId  NO 
Course  Non-Identifying  Zero or One to Zero or More        CourseId  NO 
StudentEnrollmentPeriodFee  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodFeeId  NO 
AgencyBranchCreditCard  Non-Identifying  Zero or One to Zero or More        AgencyBranchCreditCardId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
AchBatchFile  Non-Identifying  Zero or One to Zero or More        AchBatchFileId  NO 
CourseRefundPolicy  Non-Identifying  Zero or One to Zero or More        CourseRefundPolicyId  NO 
PaidDisbursement  Non-Identifying  Zero or One to Zero or More        PaidDisbursementId  NO 
Refund  Non-Identifying  Zero or One to Zero or More        RefundId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentAward  Non-Identifying  Zero or One to Zero or More        StudentAwardId  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        StudentCreditCardId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentEnrollmentPeriodFee  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodFeeId  NO 
StudentRevenueDetail  Non-Identifying  One To Zero or More        StudentRevenueDetailId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentAccountTransactionAppliedPayment  Non-Identifying  Zero or One to Zero or More          NO 
SaAutoStipendPaymentQueue  Non-Identifying  One To Zero or More          NO 
DisbursementReceiptNotification  Non-Identifying  One To Zero or More          NO 
SaStudentLedgerTermUpdatesArchive  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionCourse  Non-Identifying  One To Zero or More          NO 
SaTransCourseAmount  Non-Identifying  One To Zero or More          NO 
SaTransFee  Non-Identifying  One To Zero or More          NO 
AchBatchFileCompanyDetail  Non-Identifying  One To Zero or More          NO 
CreditCardBatchTransaction  Non-Identifying  One To Zero or More          NO 
StudentRevenueDetail  Non-Identifying  One To Zero or More          NO 
AchBatchFileCompanyDetail  Non-Identifying  One To Zero or More          NO 
GeneralLedgerReleaseBatchDetail  Non-Identifying  One To Zero or More          NO 
StipendSchedule  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionAppliedPayment  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionCourse  Non-Identifying  One To Zero or More          NO 

StudentAccountTransaction Check Constraints 
Check Constraint Name  CheckConstraint